<?php 
class CartWS_Model_ShippingCost extends Ext_Db_Table
{
	protected $_name = 'sc_shipping_cost';
	protected $_sequence = 'sc_shipping_cost_seq';
	protected $_referenceMap = array(
        'Zone' => array(
            'columns'           => array( 'shipping_zone_id' ),
            'refTableClass'     => 'Default_Model_Zone',
            'refColumns'        => array( 'shipping_zone_id' )
        )
    );
    public function getSelectWithDescr()
	{
		return $this->getAdapter()->select()
			->from( array( 'sc' => 'sc_shipping_cost' ), 
				array( 
					'fend_date' => "to_char( sc.end_date, '". self::DEFAULT_DATE_FORMAT. "')"
					, 'date_to' => "to_char( sc.date_to, '". self::DEFAULT_DATE_FORMAT. "')"
					, 'date_from' => "to_char( sc.date_from, '". self::DEFAULT_DATE_FORMAT. "')"
					, 'additional_cost_item'
					, 'default_cost'
					, 'shipping_cost_id'
					, 'shipping_zone_id'
					, 'locked' 
				)
		);
    }
}